Selecting the iMIS Security Model
The security model determines the type of user ID and password that must be entered when logging on to iMIS.
- Select File> System Setup to open the System Setup window.
- Click the SQL Security Setup button to open the SQL Security Models window.
- Check the Maintain SQL Users from iMIS option if you want the SQL user list to be same as the iMIS user list.
- Check the appropriate security model.
- Model 1 – Passthrough: The iMIS user ID and password match the database ID and password.
- Model 2 – Parallel login IDs: The iMIS user ID is appended with "_i" and the iMIS password maps to one common "master" password for all users.
- Model 3 – Unilogin: The iMIS user ID maps to one common user ID and the iMIS password maps to one common "master" password for all users.
- (Mandatory for Model 2 or Model 3) Enter the Master Password. This field cannot be blank if Model 2 or Model 3 was selected.
- (Optional) Enter the NOLOCK Keyword. Normally, when a huge report is running, the system will put locks on the data that will prevent others from modifying the same data. This is done for consistency reasons and to avoid generating old and inaccurate information. The NOLOCK Keyword option prevents the locking of data and allows data entry while a report is running. If you enter a NOLOCK Keyword, the report may not reflect the latest state of the data. There are two options that need to be set:
- In the NOLOCK Keyword field, enter noholdlock in upper or lower case for Sybase SQL Server or enter (nolock) in upper or lower case for MS SQL Server
- Select Utilities> Report Specs. Select the report, click the Edit button on the palette and then click the Parameters button. Enter NOLOCK in upper case in the Parameters field.
- Click OK.
Note: When you change a security model, make sure to click the Update All SQL Logins button on the User Names window (File> System Setup, User Passwords button).
